package com.tiansheng.microservice.mgb.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TCauserExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TCauserExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andUseridIsNull() {
            addCriterion("USERID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("USERID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("USERID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("USERID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("USERID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("USERID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("USERID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("USERID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("USERID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("USERID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("USERID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("USERID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNull() {
            addCriterion("USERTYPE is null");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNotNull() {
            addCriterion("USERTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andUsertypeEqualTo(String value) {
            addCriterion("USERTYPE =", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotEqualTo(String value) {
            addCriterion("USERTYPE <>", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThan(String value) {
            addCriterion("USERTYPE >", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThanOrEqualTo(String value) {
            addCriterion("USERTYPE >=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThan(String value) {
            addCriterion("USERTYPE <", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThanOrEqualTo(String value) {
            addCriterion("USERTYPE <=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLike(String value) {
            addCriterion("USERTYPE like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotLike(String value) {
            addCriterion("USERTYPE not like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeIn(List<String> values) {
            addCriterion("USERTYPE in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotIn(List<String> values) {
            addCriterion("USERTYPE not in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeBetween(String value1, String value2) {
            addCriterion("USERTYPE between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotBetween(String value1, String value2) {
            addCriterion("USERTYPE not between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andDivisionguidIsNull() {
            addCriterion("DIVISIONGUID is null");
            return (Criteria) this;
        }

        public Criteria andDivisionguidIsNotNull() {
            addCriterion("DIVISIONGUID is not null");
            return (Criteria) this;
        }

        public Criteria andDivisionguidEqualTo(Integer value) {
            addCriterion("DIVISIONGUID =", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidNotEqualTo(Integer value) {
            addCriterion("DIVISIONGUID <>", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidGreaterThan(Integer value) {
            addCriterion("DIVISIONGUID >", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidGreaterThanOrEqualTo(Integer value) {
            addCriterion("DIVISIONGUID >=", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidLessThan(Integer value) {
            addCriterion("DIVISIONGUID <", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidLessThanOrEqualTo(Integer value) {
            addCriterion("DIVISIONGUID <=", value, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidIn(List<Integer> values) {
            addCriterion("DIVISIONGUID in", values, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidNotIn(List<Integer> values) {
            addCriterion("DIVISIONGUID not in", values, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidBetween(Integer value1, Integer value2) {
            addCriterion("DIVISIONGUID between", value1, value2, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionguidNotBetween(Integer value1, Integer value2) {
            addCriterion("DIVISIONGUID not between", value1, value2, "divisionguid");
            return (Criteria) this;
        }

        public Criteria andDivisionnameIsNull() {
            addCriterion("DIVISIONNAME is null");
            return (Criteria) this;
        }

        public Criteria andDivisionnameIsNotNull() {
            addCriterion("DIVISIONNAME is not null");
            return (Criteria) this;
        }

        public Criteria andDivisionnameEqualTo(String value) {
            addCriterion("DIVISIONNAME =", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameNotEqualTo(String value) {
            addCriterion("DIVISIONNAME <>", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameGreaterThan(String value) {
            addCriterion("DIVISIONNAME >", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameGreaterThanOrEqualTo(String value) {
            addCriterion("DIVISIONNAME >=", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameLessThan(String value) {
            addCriterion("DIVISIONNAME <", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameLessThanOrEqualTo(String value) {
            addCriterion("DIVISIONNAME <=", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameLike(String value) {
            addCriterion("DIVISIONNAME like", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameNotLike(String value) {
            addCriterion("DIVISIONNAME not like", value, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameIn(List<String> values) {
            addCriterion("DIVISIONNAME in", values, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameNotIn(List<String> values) {
            addCriterion("DIVISIONNAME not in", values, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameBetween(String value1, String value2) {
            addCriterion("DIVISIONNAME between", value1, value2, "divisionname");
            return (Criteria) this;
        }

        public Criteria andDivisionnameNotBetween(String value1, String value2) {
            addCriterion("DIVISIONNAME not between", value1, value2, "divisionname");
            return (Criteria) this;
        }

        public Criteria andEnterguidIsNull() {
            addCriterion("ENTERGUID is null");
            return (Criteria) this;
        }

        public Criteria andEnterguidIsNotNull() {
            addCriterion("ENTERGUID is not null");
            return (Criteria) this;
        }

        public Criteria andEnterguidEqualTo(Integer value) {
            addCriterion("ENTERGUID =", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidNotEqualTo(Integer value) {
            addCriterion("ENTERGUID <>", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidGreaterThan(Integer value) {
            addCriterion("ENTERGUID >", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidGreaterThanOrEqualTo(Integer value) {
            addCriterion("ENTERGUID >=", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidLessThan(Integer value) {
            addCriterion("ENTERGUID <", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidLessThanOrEqualTo(Integer value) {
            addCriterion("ENTERGUID <=", value, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidIn(List<Integer> values) {
            addCriterion("ENTERGUID in", values, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidNotIn(List<Integer> values) {
            addCriterion("ENTERGUID not in", values, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidBetween(Integer value1, Integer value2) {
            addCriterion("ENTERGUID between", value1, value2, "enterguid");
            return (Criteria) this;
        }

        public Criteria andEnterguidNotBetween(Integer value1, Integer value2) {
            addCriterion("ENTERGUID not between", value1, value2, "enterguid");
            return (Criteria) this;
        }

        public Criteria andFRegicodeIsNull() {
            addCriterion("F_REGICODE is null");
            return (Criteria) this;
        }

        public Criteria andFRegicodeIsNotNull() {
            addCriterion("F_REGICODE is not null");
            return (Criteria) this;
        }

        public Criteria andFRegicodeEqualTo(String value) {
            addCriterion("F_REGICODE =", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeNotEqualTo(String value) {
            addCriterion("F_REGICODE <>", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeGreaterThan(String value) {
            addCriterion("F_REGICODE >", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_REGICODE >=", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeLessThan(String value) {
            addCriterion("F_REGICODE <", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeLessThanOrEqualTo(String value) {
            addCriterion("F_REGICODE <=", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeLike(String value) {
            addCriterion("F_REGICODE like", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeNotLike(String value) {
            addCriterion("F_REGICODE not like", value, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeIn(List<String> values) {
            addCriterion("F_REGICODE in", values, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeNotIn(List<String> values) {
            addCriterion("F_REGICODE not in", values, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeBetween(String value1, String value2) {
            addCriterion("F_REGICODE between", value1, value2, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFRegicodeNotBetween(String value1, String value2) {
            addCriterion("F_REGICODE not between", value1, value2, "fRegicode");
            return (Criteria) this;
        }

        public Criteria andFReginameIsNull() {
            addCriterion("F_REGINAME is null");
            return (Criteria) this;
        }

        public Criteria andFReginameIsNotNull() {
            addCriterion("F_REGINAME is not null");
            return (Criteria) this;
        }

        public Criteria andFReginameEqualTo(String value) {
            addCriterion("F_REGINAME =", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameNotEqualTo(String value) {
            addCriterion("F_REGINAME <>", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameGreaterThan(String value) {
            addCriterion("F_REGINAME >", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameGreaterThanOrEqualTo(String value) {
            addCriterion("F_REGINAME >=", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameLessThan(String value) {
            addCriterion("F_REGINAME <", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameLessThanOrEqualTo(String value) {
            addCriterion("F_REGINAME <=", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameLike(String value) {
            addCriterion("F_REGINAME like", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameNotLike(String value) {
            addCriterion("F_REGINAME not like", value, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameIn(List<String> values) {
            addCriterion("F_REGINAME in", values, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameNotIn(List<String> values) {
            addCriterion("F_REGINAME not in", values, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameBetween(String value1, String value2) {
            addCriterion("F_REGINAME between", value1, value2, "fReginame");
            return (Criteria) this;
        }

        public Criteria andFReginameNotBetween(String value1, String value2) {
            addCriterion("F_REGINAME not between", value1, value2, "fReginame");
            return (Criteria) this;
        }

        public Criteria andLogintypeIsNull() {
            addCriterion("LOGINTYPE is null");
            return (Criteria) this;
        }

        public Criteria andLogintypeIsNotNull() {
            addCriterion("LOGINTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andLogintypeEqualTo(String value) {
            addCriterion("LOGINTYPE =", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeNotEqualTo(String value) {
            addCriterion("LOGINTYPE <>", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeGreaterThan(String value) {
            addCriterion("LOGINTYPE >", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeGreaterThanOrEqualTo(String value) {
            addCriterion("LOGINTYPE >=", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeLessThan(String value) {
            addCriterion("LOGINTYPE <", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeLessThanOrEqualTo(String value) {
            addCriterion("LOGINTYPE <=", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeLike(String value) {
            addCriterion("LOGINTYPE like", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeNotLike(String value) {
            addCriterion("LOGINTYPE not like", value, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeIn(List<String> values) {
            addCriterion("LOGINTYPE in", values, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeNotIn(List<String> values) {
            addCriterion("LOGINTYPE not in", values, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeBetween(String value1, String value2) {
            addCriterion("LOGINTYPE between", value1, value2, "logintype");
            return (Criteria) this;
        }

        public Criteria andLogintypeNotBetween(String value1, String value2) {
            addCriterion("LOGINTYPE not between", value1, value2, "logintype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeIsNull() {
            addCriterion("AUTHTYPE is null");
            return (Criteria) this;
        }

        public Criteria andAuthtypeIsNotNull() {
            addCriterion("AUTHTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andAuthtypeEqualTo(String value) {
            addCriterion("AUTHTYPE =", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeNotEqualTo(String value) {
            addCriterion("AUTHTYPE <>", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeGreaterThan(String value) {
            addCriterion("AUTHTYPE >", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeGreaterThanOrEqualTo(String value) {
            addCriterion("AUTHTYPE >=", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeLessThan(String value) {
            addCriterion("AUTHTYPE <", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeLessThanOrEqualTo(String value) {
            addCriterion("AUTHTYPE <=", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeLike(String value) {
            addCriterion("AUTHTYPE like", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeNotLike(String value) {
            addCriterion("AUTHTYPE not like", value, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeIn(List<String> values) {
            addCriterion("AUTHTYPE in", values, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeNotIn(List<String> values) {
            addCriterion("AUTHTYPE not in", values, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeBetween(String value1, String value2) {
            addCriterion("AUTHTYPE between", value1, value2, "authtype");
            return (Criteria) this;
        }

        public Criteria andAuthtypeNotBetween(String value1, String value2) {
            addCriterion("AUTHTYPE not between", value1, value2, "authtype");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueIsNull() {
            addCriterion("UKEYVALUE is null");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueIsNotNull() {
            addCriterion("UKEYVALUE is not null");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueEqualTo(String value) {
            addCriterion("UKEYVALUE =", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueNotEqualTo(String value) {
            addCriterion("UKEYVALUE <>", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueGreaterThan(String value) {
            addCriterion("UKEYVALUE >", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueGreaterThanOrEqualTo(String value) {
            addCriterion("UKEYVALUE >=", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueLessThan(String value) {
            addCriterion("UKEYVALUE <", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueLessThanOrEqualTo(String value) {
            addCriterion("UKEYVALUE <=", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueLike(String value) {
            addCriterion("UKEYVALUE like", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueNotLike(String value) {
            addCriterion("UKEYVALUE not like", value, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueIn(List<String> values) {
            addCriterion("UKEYVALUE in", values, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueNotIn(List<String> values) {
            addCriterion("UKEYVALUE not in", values, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueBetween(String value1, String value2) {
            addCriterion("UKEYVALUE between", value1, value2, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andUkeyvalueNotBetween(String value1, String value2) {
            addCriterion("UKEYVALUE not between", value1, value2, "ukeyvalue");
            return (Criteria) this;
        }

        public Criteria andSexcodeIsNull() {
            addCriterion("SEXCODE is null");
            return (Criteria) this;
        }

        public Criteria andSexcodeIsNotNull() {
            addCriterion("SEXCODE is not null");
            return (Criteria) this;
        }

        public Criteria andSexcodeEqualTo(String value) {
            addCriterion("SEXCODE =", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeNotEqualTo(String value) {
            addCriterion("SEXCODE <>", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeGreaterThan(String value) {
            addCriterion("SEXCODE >", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeGreaterThanOrEqualTo(String value) {
            addCriterion("SEXCODE >=", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeLessThan(String value) {
            addCriterion("SEXCODE <", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeLessThanOrEqualTo(String value) {
            addCriterion("SEXCODE <=", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeLike(String value) {
            addCriterion("SEXCODE like", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeNotLike(String value) {
            addCriterion("SEXCODE not like", value, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeIn(List<String> values) {
            addCriterion("SEXCODE in", values, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeNotIn(List<String> values) {
            addCriterion("SEXCODE not in", values, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeBetween(String value1, String value2) {
            addCriterion("SEXCODE between", value1, value2, "sexcode");
            return (Criteria) this;
        }

        public Criteria andSexcodeNotBetween(String value1, String value2) {
            addCriterion("SEXCODE not between", value1, value2, "sexcode");
            return (Criteria) this;
        }

        public Criteria andFinanceidIsNull() {
            addCriterion("FINANCEID is null");
            return (Criteria) this;
        }

        public Criteria andFinanceidIsNotNull() {
            addCriterion("FINANCEID is not null");
            return (Criteria) this;
        }

        public Criteria andFinanceidEqualTo(Integer value) {
            addCriterion("FINANCEID =", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidNotEqualTo(Integer value) {
            addCriterion("FINANCEID <>", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidGreaterThan(Integer value) {
            addCriterion("FINANCEID >", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("FINANCEID >=", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidLessThan(Integer value) {
            addCriterion("FINANCEID <", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidLessThanOrEqualTo(Integer value) {
            addCriterion("FINANCEID <=", value, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidIn(List<Integer> values) {
            addCriterion("FINANCEID in", values, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidNotIn(List<Integer> values) {
            addCriterion("FINANCEID not in", values, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidBetween(Integer value1, Integer value2) {
            addCriterion("FINANCEID between", value1, value2, "financeid");
            return (Criteria) this;
        }

        public Criteria andFinanceidNotBetween(Integer value1, Integer value2) {
            addCriterion("FINANCEID not between", value1, value2, "financeid");
            return (Criteria) this;
        }

        public Criteria andIsbncodeIsNull() {
            addCriterion("ISBNCODE is null");
            return (Criteria) this;
        }

        public Criteria andIsbncodeIsNotNull() {
            addCriterion("ISBNCODE is not null");
            return (Criteria) this;
        }

        public Criteria andIsbncodeEqualTo(String value) {
            addCriterion("ISBNCODE =", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeNotEqualTo(String value) {
            addCriterion("ISBNCODE <>", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeGreaterThan(String value) {
            addCriterion("ISBNCODE >", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeGreaterThanOrEqualTo(String value) {
            addCriterion("ISBNCODE >=", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeLessThan(String value) {
            addCriterion("ISBNCODE <", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeLessThanOrEqualTo(String value) {
            addCriterion("ISBNCODE <=", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeLike(String value) {
            addCriterion("ISBNCODE like", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeNotLike(String value) {
            addCriterion("ISBNCODE not like", value, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeIn(List<String> values) {
            addCriterion("ISBNCODE in", values, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeNotIn(List<String> values) {
            addCriterion("ISBNCODE not in", values, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeBetween(String value1, String value2) {
            addCriterion("ISBNCODE between", value1, value2, "isbncode");
            return (Criteria) this;
        }

        public Criteria andIsbncodeNotBetween(String value1, String value2) {
            addCriterion("ISBNCODE not between", value1, value2, "isbncode");
            return (Criteria) this;
        }

        public Criteria andManageridIsNull() {
            addCriterion("MANAGERID is null");
            return (Criteria) this;
        }

        public Criteria andManageridIsNotNull() {
            addCriterion("MANAGERID is not null");
            return (Criteria) this;
        }

        public Criteria andManageridEqualTo(Integer value) {
            addCriterion("MANAGERID =", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotEqualTo(Integer value) {
            addCriterion("MANAGERID <>", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridGreaterThan(Integer value) {
            addCriterion("MANAGERID >", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridGreaterThanOrEqualTo(Integer value) {
            addCriterion("MANAGERID >=", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridLessThan(Integer value) {
            addCriterion("MANAGERID <", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridLessThanOrEqualTo(Integer value) {
            addCriterion("MANAGERID <=", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridIn(List<Integer> values) {
            addCriterion("MANAGERID in", values, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotIn(List<Integer> values) {
            addCriterion("MANAGERID not in", values, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridBetween(Integer value1, Integer value2) {
            addCriterion("MANAGERID between", value1, value2, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotBetween(Integer value1, Integer value2) {
            addCriterion("MANAGERID not between", value1, value2, "managerid");
            return (Criteria) this;
        }

        public Criteria andOverduedateIsNull() {
            addCriterion("OVERDUEDATE is null");
            return (Criteria) this;
        }

        public Criteria andOverduedateIsNotNull() {
            addCriterion("OVERDUEDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOverduedateEqualTo(Date value) {
            addCriterion("OVERDUEDATE =", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateNotEqualTo(Date value) {
            addCriterion("OVERDUEDATE <>", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateGreaterThan(Date value) {
            addCriterion("OVERDUEDATE >", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateGreaterThanOrEqualTo(Date value) {
            addCriterion("OVERDUEDATE >=", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateLessThan(Date value) {
            addCriterion("OVERDUEDATE <", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateLessThanOrEqualTo(Date value) {
            addCriterion("OVERDUEDATE <=", value, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateIn(List<Date> values) {
            addCriterion("OVERDUEDATE in", values, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateNotIn(List<Date> values) {
            addCriterion("OVERDUEDATE not in", values, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateBetween(Date value1, Date value2) {
            addCriterion("OVERDUEDATE between", value1, value2, "overduedate");
            return (Criteria) this;
        }

        public Criteria andOverduedateNotBetween(Date value1, Date value2) {
            addCriterion("OVERDUEDATE not between", value1, value2, "overduedate");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andMobiphoneIsNull() {
            addCriterion("MOBIPHONE is null");
            return (Criteria) this;
        }

        public Criteria andMobiphoneIsNotNull() {
            addCriterion("MOBIPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andMobiphoneEqualTo(String value) {
            addCriterion("MOBIPHONE =", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneNotEqualTo(String value) {
            addCriterion("MOBIPHONE <>", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneGreaterThan(String value) {
            addCriterion("MOBIPHONE >", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneGreaterThanOrEqualTo(String value) {
            addCriterion("MOBIPHONE >=", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneLessThan(String value) {
            addCriterion("MOBIPHONE <", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneLessThanOrEqualTo(String value) {
            addCriterion("MOBIPHONE <=", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneLike(String value) {
            addCriterion("MOBIPHONE like", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneNotLike(String value) {
            addCriterion("MOBIPHONE not like", value, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneIn(List<String> values) {
            addCriterion("MOBIPHONE in", values, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneNotIn(List<String> values) {
            addCriterion("MOBIPHONE not in", values, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneBetween(String value1, String value2) {
            addCriterion("MOBIPHONE between", value1, value2, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andMobiphoneNotBetween(String value1, String value2) {
            addCriterion("MOBIPHONE not between", value1, value2, "mobiphone");
            return (Criteria) this;
        }

        public Criteria andPhonenoIsNull() {
            addCriterion("PHONENO is null");
            return (Criteria) this;
        }

        public Criteria andPhonenoIsNotNull() {
            addCriterion("PHONENO is not null");
            return (Criteria) this;
        }

        public Criteria andPhonenoEqualTo(String value) {
            addCriterion("PHONENO =", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoNotEqualTo(String value) {
            addCriterion("PHONENO <>", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoGreaterThan(String value) {
            addCriterion("PHONENO >", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoGreaterThanOrEqualTo(String value) {
            addCriterion("PHONENO >=", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoLessThan(String value) {
            addCriterion("PHONENO <", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoLessThanOrEqualTo(String value) {
            addCriterion("PHONENO <=", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoLike(String value) {
            addCriterion("PHONENO like", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoNotLike(String value) {
            addCriterion("PHONENO not like", value, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoIn(List<String> values) {
            addCriterion("PHONENO in", values, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoNotIn(List<String> values) {
            addCriterion("PHONENO not in", values, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoBetween(String value1, String value2) {
            addCriterion("PHONENO between", value1, value2, "phoneno");
            return (Criteria) this;
        }

        public Criteria andPhonenoNotBetween(String value1, String value2) {
            addCriterion("PHONENO not between", value1, value2, "phoneno");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andInCodeIsNull() {
            addCriterion("IN_CODE is null");
            return (Criteria) this;
        }

        public Criteria andInCodeIsNotNull() {
            addCriterion("IN_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andInCodeEqualTo(String value) {
            addCriterion("IN_CODE =", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeNotEqualTo(String value) {
            addCriterion("IN_CODE <>", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeGreaterThan(String value) {
            addCriterion("IN_CODE >", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeGreaterThanOrEqualTo(String value) {
            addCriterion("IN_CODE >=", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeLessThan(String value) {
            addCriterion("IN_CODE <", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeLessThanOrEqualTo(String value) {
            addCriterion("IN_CODE <=", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeLike(String value) {
            addCriterion("IN_CODE like", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeNotLike(String value) {
            addCriterion("IN_CODE not like", value, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeIn(List<String> values) {
            addCriterion("IN_CODE in", values, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeNotIn(List<String> values) {
            addCriterion("IN_CODE not in", values, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeBetween(String value1, String value2) {
            addCriterion("IN_CODE between", value1, value2, "inCode");
            return (Criteria) this;
        }

        public Criteria andInCodeNotBetween(String value1, String value2) {
            addCriterion("IN_CODE not between", value1, value2, "inCode");
            return (Criteria) this;
        }

        public Criteria andUsertokenIsNull() {
            addCriterion("USERTOKEN is null");
            return (Criteria) this;
        }

        public Criteria andUsertokenIsNotNull() {
            addCriterion("USERTOKEN is not null");
            return (Criteria) this;
        }

        public Criteria andUsertokenEqualTo(String value) {
            addCriterion("USERTOKEN =", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenNotEqualTo(String value) {
            addCriterion("USERTOKEN <>", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenGreaterThan(String value) {
            addCriterion("USERTOKEN >", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenGreaterThanOrEqualTo(String value) {
            addCriterion("USERTOKEN >=", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenLessThan(String value) {
            addCriterion("USERTOKEN <", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenLessThanOrEqualTo(String value) {
            addCriterion("USERTOKEN <=", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenLike(String value) {
            addCriterion("USERTOKEN like", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenNotLike(String value) {
            addCriterion("USERTOKEN not like", value, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenIn(List<String> values) {
            addCriterion("USERTOKEN in", values, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenNotIn(List<String> values) {
            addCriterion("USERTOKEN not in", values, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenBetween(String value1, String value2) {
            addCriterion("USERTOKEN between", value1, value2, "usertoken");
            return (Criteria) this;
        }

        public Criteria andUsertokenNotBetween(String value1, String value2) {
            addCriterion("USERTOKEN not between", value1, value2, "usertoken");
            return (Criteria) this;
        }

        public Criteria andLevelNumIsNull() {
            addCriterion("LEVEL_NUM is null");
            return (Criteria) this;
        }

        public Criteria andLevelNumIsNotNull() {
            addCriterion("LEVEL_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andLevelNumEqualTo(Integer value) {
            addCriterion("LEVEL_NUM =", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumNotEqualTo(Integer value) {
            addCriterion("LEVEL_NUM <>", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumGreaterThan(Integer value) {
            addCriterion("LEVEL_NUM >", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("LEVEL_NUM >=", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumLessThan(Integer value) {
            addCriterion("LEVEL_NUM <", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumLessThanOrEqualTo(Integer value) {
            addCriterion("LEVEL_NUM <=", value, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumIn(List<Integer> values) {
            addCriterion("LEVEL_NUM in", values, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumNotIn(List<Integer> values) {
            addCriterion("LEVEL_NUM not in", values, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumBetween(Integer value1, Integer value2) {
            addCriterion("LEVEL_NUM between", value1, value2, "levelNum");
            return (Criteria) this;
        }

        public Criteria andLevelNumNotBetween(Integer value1, Integer value2) {
            addCriterion("LEVEL_NUM not between", value1, value2, "levelNum");
            return (Criteria) this;
        }

        public Criteria andIsleafIsNull() {
            addCriterion("ISLEAF is null");
            return (Criteria) this;
        }

        public Criteria andIsleafIsNotNull() {
            addCriterion("ISLEAF is not null");
            return (Criteria) this;
        }

        public Criteria andIsleafEqualTo(Integer value) {
            addCriterion("ISLEAF =", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafNotEqualTo(Integer value) {
            addCriterion("ISLEAF <>", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafGreaterThan(Integer value) {
            addCriterion("ISLEAF >", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafGreaterThanOrEqualTo(Integer value) {
            addCriterion("ISLEAF >=", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafLessThan(Integer value) {
            addCriterion("ISLEAF <", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafLessThanOrEqualTo(Integer value) {
            addCriterion("ISLEAF <=", value, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafIn(List<Integer> values) {
            addCriterion("ISLEAF in", values, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafNotIn(List<Integer> values) {
            addCriterion("ISLEAF not in", values, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafBetween(Integer value1, Integer value2) {
            addCriterion("ISLEAF between", value1, value2, "isleaf");
            return (Criteria) this;
        }

        public Criteria andIsleafNotBetween(Integer value1, Integer value2) {
            addCriterion("ISLEAF not between", value1, value2, "isleaf");
            return (Criteria) this;
        }

        public Criteria andDorderIsNull() {
            addCriterion("DORDER is null");
            return (Criteria) this;
        }

        public Criteria andDorderIsNotNull() {
            addCriterion("DORDER is not null");
            return (Criteria) this;
        }

        public Criteria andDorderEqualTo(String value) {
            addCriterion("DORDER =", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderNotEqualTo(String value) {
            addCriterion("DORDER <>", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderGreaterThan(String value) {
            addCriterion("DORDER >", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderGreaterThanOrEqualTo(String value) {
            addCriterion("DORDER >=", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderLessThan(String value) {
            addCriterion("DORDER <", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderLessThanOrEqualTo(String value) {
            addCriterion("DORDER <=", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderLike(String value) {
            addCriterion("DORDER like", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderNotLike(String value) {
            addCriterion("DORDER not like", value, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderIn(List<String> values) {
            addCriterion("DORDER in", values, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderNotIn(List<String> values) {
            addCriterion("DORDER not in", values, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderBetween(String value1, String value2) {
            addCriterion("DORDER between", value1, value2, "dorder");
            return (Criteria) this;
        }

        public Criteria andDorderNotBetween(String value1, String value2) {
            addCriterion("DORDER not between", value1, value2, "dorder");
            return (Criteria) this;
        }

        public Criteria andIdnumberIsNull() {
            addCriterion("IDNUMBER is null");
            return (Criteria) this;
        }

        public Criteria andIdnumberIsNotNull() {
            addCriterion("IDNUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andIdnumberEqualTo(String value) {
            addCriterion("IDNUMBER =", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberNotEqualTo(String value) {
            addCriterion("IDNUMBER <>", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberGreaterThan(String value) {
            addCriterion("IDNUMBER >", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberGreaterThanOrEqualTo(String value) {
            addCriterion("IDNUMBER >=", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberLessThan(String value) {
            addCriterion("IDNUMBER <", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberLessThanOrEqualTo(String value) {
            addCriterion("IDNUMBER <=", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberLike(String value) {
            addCriterion("IDNUMBER like", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberNotLike(String value) {
            addCriterion("IDNUMBER not like", value, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberIn(List<String> values) {
            addCriterion("IDNUMBER in", values, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberNotIn(List<String> values) {
            addCriterion("IDNUMBER not in", values, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberBetween(String value1, String value2) {
            addCriterion("IDNUMBER between", value1, value2, "idnumber");
            return (Criteria) this;
        }

        public Criteria andIdnumberNotBetween(String value1, String value2) {
            addCriterion("IDNUMBER not between", value1, value2, "idnumber");
            return (Criteria) this;
        }

        public Criteria andNotbeforeIsNull() {
            addCriterion("NOTBEFORE is null");
            return (Criteria) this;
        }

        public Criteria andNotbeforeIsNotNull() {
            addCriterion("NOTBEFORE is not null");
            return (Criteria) this;
        }

        public Criteria andNotbeforeEqualTo(Date value) {
            addCriterionForJDBCDate("NOTBEFORE =", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeNotEqualTo(Date value) {
            addCriterionForJDBCDate("NOTBEFORE <>", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeGreaterThan(Date value) {
            addCriterionForJDBCDate("NOTBEFORE >", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("NOTBEFORE >=", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeLessThan(Date value) {
            addCriterionForJDBCDate("NOTBEFORE <", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("NOTBEFORE <=", value, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeIn(List<Date> values) {
            addCriterionForJDBCDate("NOTBEFORE in", values, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeNotIn(List<Date> values) {
            addCriterionForJDBCDate("NOTBEFORE not in", values, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("NOTBEFORE between", value1, value2, "notbefore");
            return (Criteria) this;
        }

        public Criteria andNotbeforeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("NOTBEFORE not between", value1, value2, "notbefore");
            return (Criteria) this;
        }

        public Criteria andValidatedaysIsNull() {
            addCriterion("VALIDATEDAYS is null");
            return (Criteria) this;
        }

        public Criteria andValidatedaysIsNotNull() {
            addCriterion("VALIDATEDAYS is not null");
            return (Criteria) this;
        }

        public Criteria andValidatedaysEqualTo(String value) {
            addCriterion("VALIDATEDAYS =", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysNotEqualTo(String value) {
            addCriterion("VALIDATEDAYS <>", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysGreaterThan(String value) {
            addCriterion("VALIDATEDAYS >", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysGreaterThanOrEqualTo(String value) {
            addCriterion("VALIDATEDAYS >=", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysLessThan(String value) {
            addCriterion("VALIDATEDAYS <", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysLessThanOrEqualTo(String value) {
            addCriterion("VALIDATEDAYS <=", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysLike(String value) {
            addCriterion("VALIDATEDAYS like", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysNotLike(String value) {
            addCriterion("VALIDATEDAYS not like", value, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysIn(List<String> values) {
            addCriterion("VALIDATEDAYS in", values, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysNotIn(List<String> values) {
            addCriterion("VALIDATEDAYS not in", values, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysBetween(String value1, String value2) {
            addCriterion("VALIDATEDAYS between", value1, value2, "validatedays");
            return (Criteria) this;
        }

        public Criteria andValidatedaysNotBetween(String value1, String value2) {
            addCriterion("VALIDATEDAYS not between", value1, value2, "validatedays");
            return (Criteria) this;
        }

        public Criteria andCerttypeIsNull() {
            addCriterion("CERTTYPE is null");
            return (Criteria) this;
        }

        public Criteria andCerttypeIsNotNull() {
            addCriterion("CERTTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCerttypeEqualTo(String value) {
            addCriterion("CERTTYPE =", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeNotEqualTo(String value) {
            addCriterion("CERTTYPE <>", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeGreaterThan(String value) {
            addCriterion("CERTTYPE >", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeGreaterThanOrEqualTo(String value) {
            addCriterion("CERTTYPE >=", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeLessThan(String value) {
            addCriterion("CERTTYPE <", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeLessThanOrEqualTo(String value) {
            addCriterion("CERTTYPE <=", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeLike(String value) {
            addCriterion("CERTTYPE like", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeNotLike(String value) {
            addCriterion("CERTTYPE not like", value, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeIn(List<String> values) {
            addCriterion("CERTTYPE in", values, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeNotIn(List<String> values) {
            addCriterion("CERTTYPE not in", values, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeBetween(String value1, String value2) {
            addCriterion("CERTTYPE between", value1, value2, "certtype");
            return (Criteria) this;
        }

        public Criteria andCerttypeNotBetween(String value1, String value2) {
            addCriterion("CERTTYPE not between", value1, value2, "certtype");
            return (Criteria) this;
        }

        public Criteria andIsapplyIsNull() {
            addCriterion("ISAPPLY is null");
            return (Criteria) this;
        }

        public Criteria andIsapplyIsNotNull() {
            addCriterion("ISAPPLY is not null");
            return (Criteria) this;
        }

        public Criteria andIsapplyEqualTo(String value) {
            addCriterion("ISAPPLY =", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyNotEqualTo(String value) {
            addCriterion("ISAPPLY <>", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyGreaterThan(String value) {
            addCriterion("ISAPPLY >", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyGreaterThanOrEqualTo(String value) {
            addCriterion("ISAPPLY >=", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyLessThan(String value) {
            addCriterion("ISAPPLY <", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyLessThanOrEqualTo(String value) {
            addCriterion("ISAPPLY <=", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyLike(String value) {
            addCriterion("ISAPPLY like", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyNotLike(String value) {
            addCriterion("ISAPPLY not like", value, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyIn(List<String> values) {
            addCriterion("ISAPPLY in", values, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyNotIn(List<String> values) {
            addCriterion("ISAPPLY not in", values, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyBetween(String value1, String value2) {
            addCriterion("ISAPPLY between", value1, value2, "isapply");
            return (Criteria) this;
        }

        public Criteria andIsapplyNotBetween(String value1, String value2) {
            addCriterion("ISAPPLY not between", value1, value2, "isapply");
            return (Criteria) this;
        }

        public Criteria andRefcodeIsNull() {
            addCriterion("REFCODE is null");
            return (Criteria) this;
        }

        public Criteria andRefcodeIsNotNull() {
            addCriterion("REFCODE is not null");
            return (Criteria) this;
        }

        public Criteria andRefcodeEqualTo(String value) {
            addCriterion("REFCODE =", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeNotEqualTo(String value) {
            addCriterion("REFCODE <>", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeGreaterThan(String value) {
            addCriterion("REFCODE >", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeGreaterThanOrEqualTo(String value) {
            addCriterion("REFCODE >=", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeLessThan(String value) {
            addCriterion("REFCODE <", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeLessThanOrEqualTo(String value) {
            addCriterion("REFCODE <=", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeLike(String value) {
            addCriterion("REFCODE like", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeNotLike(String value) {
            addCriterion("REFCODE not like", value, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeIn(List<String> values) {
            addCriterion("REFCODE in", values, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeNotIn(List<String> values) {
            addCriterion("REFCODE not in", values, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeBetween(String value1, String value2) {
            addCriterion("REFCODE between", value1, value2, "refcode");
            return (Criteria) this;
        }

        public Criteria andRefcodeNotBetween(String value1, String value2) {
            addCriterion("REFCODE not between", value1, value2, "refcode");
            return (Criteria) this;
        }

        public Criteria andUkidIsNull() {
            addCriterion("UKID is null");
            return (Criteria) this;
        }

        public Criteria andUkidIsNotNull() {
            addCriterion("UKID is not null");
            return (Criteria) this;
        }

        public Criteria andUkidEqualTo(String value) {
            addCriterion("UKID =", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidNotEqualTo(String value) {
            addCriterion("UKID <>", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidGreaterThan(String value) {
            addCriterion("UKID >", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidGreaterThanOrEqualTo(String value) {
            addCriterion("UKID >=", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidLessThan(String value) {
            addCriterion("UKID <", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidLessThanOrEqualTo(String value) {
            addCriterion("UKID <=", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidLike(String value) {
            addCriterion("UKID like", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidNotLike(String value) {
            addCriterion("UKID not like", value, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidIn(List<String> values) {
            addCriterion("UKID in", values, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidNotIn(List<String> values) {
            addCriterion("UKID not in", values, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidBetween(String value1, String value2) {
            addCriterion("UKID between", value1, value2, "ukid");
            return (Criteria) this;
        }

        public Criteria andUkidNotBetween(String value1, String value2) {
            addCriterion("UKID not between", value1, value2, "ukid");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}